Notebook A1

Project: "Intra-Regional Migration and Transportation in New York Metro Area"

Due to the large data our team is working with, there are a total of four notebooks submitted for this midterm (Two from each team member)

I also outlined the notebook into the Table of Content - hope it helps to read through the notebook</font>

Research questions in this specific notebook:

Section 0. Import All Modules and Set Up Notebook

Section 1. Reproduce and Visualize Moving Trend During COVID

Section 1.1 Moving Trend in 2019 and 2020 COVID Time

I'm going to reproduce the findings from the existing reserach (https://www.mymove.com/moving/covid-19/coronavirus-moving-trends/).

First, I typed all data in excel and exported to CSV as the raw dataset for this section.

Then, I'm importing them:

Finding1: Moving trend during COVID and same period in 2019:

Section 1.2 Moving Trend in Various States

The Finding2: 5 states with most net gains and 5 states with most net loss of moving during COVID:

Section 1.3 Moving Trend in Various Cities and Areas

Finding3: Top 5 cities/areas with most net gains and Top 5 cities/areas with most net loss of moving during COVID:

Section 2. Capture National Out-Migration Trend in 2018

Section 2.1 Prepare Geo-Data for Metro Areas in the U.S.

The above geodata is ready to use

2. Migration CSV Data Process

3. Sort by Out-Migration Population